/*
 * Copyright 2021 spring-boot-extension the original author or authors.
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *       https://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 *
 */

package com.livk.dynamic.controller;

import com.livk.core.dynamic.DataSourceContextHolder;
import org.springframework.beans.factory.InitializingBean;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.context.ApplicationContext;
import org.springframework.core.io.Resource;
import org.springframework.jdbc.datasource.init.ScriptUtils;
import org.springframework.stereotype.Component;

import javax.sql.DataSource;

/**
 * @author livk
 */
@Component
public class DataSourceInit implements InitializingBean {

	@Autowired
	ApplicationContext applicationContext;

	@Value("classpath:mysql.sql")
	private Resource initMysql;

	@Value("classpath:pgsql.sql")
	private Resource initPgsql;

	@Override
	public void afterPropertiesSet() throws Exception {
		DataSourceContextHolder.switchDataSource("mysql");
		ScriptUtils.executeSqlScript(applicationContext.getBean(DataSource.class).getConnection(), initMysql);
		DataSourceContextHolder.switchDataSource("pgsql");
		ScriptUtils.executeSqlScript(applicationContext.getBean(DataSource.class).getConnection(), initPgsql);
		DataSourceContextHolder.clear();
	}

}
